ALTER TABLE `db_icportal`.`ic_infection_devices`   
  ADD COLUMN `device_first_event` DATETIME NULL AFTER `deivce_surgery_date`;

ALTER TABLE `db_icportal`.`ic_infection_devices`   
  ADD COLUMN `deivce_intubation_date` DATETIME NULL AFTER `device_first_event`;

????????????????????????????????????????????????????????????


ALTER TABLE `db_icportal`.`ic_lovs`   
  CHANGE `lov_name` `organism_name` VARCHAR(255) CHARSET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  CHANGE `lov_type` `antibiotic_class_1` VARCHAR(255) CHARSET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  ADD COLUMN `antibiotic_class_2` VARCHAR(255) NULL AFTER `lov_updation`,
  ADD COLUMN `antibiotic_class_3` VARCHAR(255) NULL AFTER `antibiotic_class_2`,
  ADD COLUMN `antibiotic_class_4` VARCHAR(255) NULL AFTER `antibiotic_class_3`,
  ADD COLUMN `antibiotic_class_5` VARCHAR(255) NULL AFTER `antibiotic_class_4`,
  ADD COLUMN `antibiotic_class_6` VARCHAR(255) NULL AFTER `antibiotic_class_5`,
  ADD COLUMN `antibiotic_class_7` VARCHAR(255) NULL AFTER `antibiotic_class_6`,
  ADD COLUMN `antibiotic_class_8` VARCHAR(255) NULL AFTER `antibiotic_class_7`,
  ADD COLUMN `antibiotic_class_9` VARCHAR(255) NULL AFTER `antibiotic_class_8`,
  ADD COLUMN `mbr_name` VARCHAR(255) NULL AFTER `antibiotic_class_9`;

